<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Regular Expressions</title>
<link type="text/css" href="style.css" rel="stylesheet"></link>
</head>
<body>
	<h1>Regular Expressions:</h1>
	<hr>
	<p>
	In the first page of the wizard, set the name of the pattern so that you can find it easily. 
	</p>
	<p>
	In the second page, set the regular pattern to be used in analyses.  
	<br>
	<b><u>The pattern must be surrounded by single quotes " ' ".</u></b>
	<br>
	Once the pattern is created, you can drag &amp; drop it onto a column in the Multiple Column Analysis editor.
	</p>
	<p>
	Note:
	<br>
	Regular patterns are different from SQL patterns. 
	<br>
	For example, if you search strings starting with 'S', the regular pattern is 'S.*', not 'S%'.
	<br>
	Please refer to the documentation of your Database Management System for more details.
	</p>
	<br>
	See also:
	<br>
	MySQL Regular Expressions:	<a href="http://dev.mysql.com/doc/refman/5.0/en/regexp.html">http://dev.mysql.com/doc/refman/5.0/en/regexp.html</a>
	<br>
	Oracle Regular Expressions:  <a href="http://www.oracle.com/technology/obe/obe10gdb/develop/regexp/regexp.htm">http://www.oracle.com/technology/obe/obe10gdb/develop/regexp/regexp.htm</a>	
	<br>
	SQL Server 2005 Regular Expressions: <a href="http://msdn.microsoft.com/en-us/magazine/cc163473.aspx">http://msdn.microsoft.com/en-us/magazine/cc163473.aspx</a>
	<br>
	PostgreSQL Regular Expressions:  <a href="http://www.postgresql.org/docs/current/static/functions-matching.html">http://www.postgresql.org/docs/current/static/functions-matching.html</a>
	<br>
	Informix Regular Expressions:  <a href="http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_regexp.html">http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_regexp.html</a>
	<br>
	SQLite Regular Expressions: <a href="http://www.sqlite.org/lang_expr.html">http://www.sqlite.org/lang_expr.html</a>	
	<br>
	DB2 Regular Expressions: <a href="http://www.ibm.com/developerworks/db2/library/techarticle/0301stolze/0301stolze.html">http://www.ibm.com/developerworks/db2/library/techarticle/0301stolze/0301stolze.html</a>
	</p>

</body>
</html>